home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vrpt12headers.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
32 lines
CREATE OR REPLACE VIEW VRPT12HEADERS AS
SELECT
RPTNAMES.short_name,
r1.header h1, r2.header h2, r3.header h3, r4.header h4,
r5.header h5, r6.header h6, r7.header h7, r8.header h8,
r9.header h9, r10.header h10, r11.header h11, r12.header h12
FROM RPTNAMES,
RPTHEADERS r1, RPTHEADERS r2, RPTHEADERS r3, RPTHEADERS r4,
RPTHEADERS r5, RPTHEADERS r6, RPTHEADERS r7, RPTHEADERS r8,
RPTHEADERS r9, RPTHEADERS r10, RPTHEADERS r11, RPTHEADERS r12
WHERE
RPTNAMES.max_columns = 12 AND
r1.rptclass = 1 AND r2.rptclass = 2 AND
r3.rptclass = 3 AND r4.rptclass = 4 AND
r5.rptclass = 5 AND r6.rptclass = 6 AND
r7.rptclass = 7 AND r8.rptclass = 8 AND
r9.rptclass = 9 AND r10.rptclass = 10 AND
r11.rptclass = 11 AND r12.rptclass = 12 AND
r1.report_indx = RPTNAMES.report_indx AND
r2.report_indx = RPTNAMES.report_indx AND
r3.report_indx = RPTNAMES.report_indx AND
r4.report_indx = RPTNAMES.report_indx AND
r5.report_indx = RPTNAMES.report_indx AND
r6.report_indx = RPTNAMES.report_indx AND
r7.report_indx = RPTNAMES.report_indx AND
r8.report_indx = RPTNAMES.report_indx AND
r9.report_indx = RPTNAMES.report_indx AND
r10.report_indx = RPTNAMES.report_indx AND
r11.report_indx = RPTNAMES.report_indx AND
r12.report_indx = RPTNAMES.report_indx
;